IF NOT EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'KalaId'
          AND COLUMN_NAME = 'TaxPercent'
)
    ALTER TABLE dbo.KalaId ADD TaxPercent REAL NULL DEFAULT (0);

IF NOT EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'IHIOPrescription'
          AND COLUMN_NAME = 'OrderId'
)
    ALTER TABLE dbo.IHIOPrescription ADD OrderId BIGINT NULL DEFAULT (0);


IF NOT EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'TaminPrescription'
          AND COLUMN_NAME = 'OrderId'
)
    ALTER TABLE dbo.TaminPrescription ADD OrderId BIGINT NULL DEFAULT (0);
IF NOT EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'tmpDrugH'
          AND COLUMN_NAME = 'OrderId'
)
    ALTER TABLE dbo.TmpDrugH ADD OrderId BIGINT NULL DEFAULT (0);


IF NOT EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'DrugH'
          AND COLUMN_NAME = 'OrderId'
)
    ALTER TABLE dbo.DrugH ADD OrderId BIGINT NULL DEFAULT (0);



IF NOT EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'KalaId'
          AND COLUMN_NAME = 'EquipmentCode'
)
    ALTER TABLE dbo.KalaId ADD EquipmentCode VARCHAR(6) NULL;


IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[AddIHIOPrescription]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[AddIHIOPrescription];

IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[AddTaminPrescription]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[AddTaminPrescription];

IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[EPMCalculateSupplementaryInsurance]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[EPMCalculateSupplementaryInsurance];


IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[EPMPreCalculateSupplementaryInsurance]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[EPMPreCalculateSupplementaryInsurance];

IF NOT EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'EPMPrescriptionTransaction'
          AND COLUMN_NAME = 'TaxTotalAmount'
)
    ALTER TABLE dbo.EPMPrescriptionTransaction
    ADD TaxTotalAmount MONEY NULL
            DEFAULT (0);

IF NOT EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'TaminPrescriptionDetail'
          AND COLUMN_NAME = 'HasDuty'
)
    ALTER TABLE dbo.TaminPrescriptionDetail ADD HasDuty BIT DEFAULT (0);

IF NOT EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'IHIOPrescriptionDetail'
          AND COLUMN_NAME = 'HasDuty'
)
    ALTER TABLE dbo.IHIOPrescriptionDetail ADD HasDuty BIT DEFAULT (0);

IF NOT EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'TTACPrescriptionDetail'
          AND COLUMN_NAME = 'HasDuty'
)
    ALTER TABLE dbo.TTACPrescriptionDetail ADD HasDuty BIT DEFAULT (0);
